Tabela CO_DICTKITCHEN

Definicja tabeli CO_DICTKITCHEN

Name

CO_DICTKITCHEN

Code

CO_DICTKITCHEN

Comment

 


Lista kolumn tabeli CO_DICTKITCHEN

Name

Code

CO_DICTKITCHENID

CO_DICTKITCHENID

KitchenTypeId

KitchenTypeId

NAME

NAME

SHORTNAME

SHORTNAME

VISIBLE

VISIBLE

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT

ExternalId

ExternalId


Kolumna CO_DICTKITCHENID tabeli CO_DICTKITCHEN

Definicja kolumny CO_DICTKITCHENID tabeli CO_DICTKITCHEN

Name

CO_DICTKITCHENID

Code

CO_DICTKITCHENID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna KitchenTypeId tabeli CO_DICTKITCHEN

Definicja kolumny KitchenTypeId tabeli CO_DICTKITCHEN

Name

KitchenTypeId

Code

KitchenTypeId

Data Type

NUMBER(10)

Mandatory

No

Comment

ID typu kuchni


Kolumna NAME tabeli CO_DICTKITCHEN

Definicja kolumny NAME tabeli CO_DICTKITCHEN

Name

NAME

Code

NAME

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna SHORTNAME tabeli CO_DICTKITCHEN

Definicja kolumny SHORTNAME tabeli CO_DICTKITCHEN

Name

SHORTNAME

Code

SHORTNAME

Data Type

VARCHAR2(60)

Mandatory

Yes

Comment

 


Kolumna VISIBLE tabeli CO_DICTKITCHEN

Definicja kolumny VISIBLE tabeli CO_DICTKITCHEN

Name

VISIBLE

Code

VISIBLE

Data Type

NUMBER(5)

Mandatory

Yes

Comment

 


Kolumna INSERTDATE tabeli CO_DICTKITCHEN

Definicja kolumny INSERTDATE tabeli CO_DICTKITCHEN

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_DICTKITCHEN

Definicja kolumny INSERTINGPERSON tabeli CO_DICTKITCHEN

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_DICTKITCHEN

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_DICTKITCHEN

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_DICTKITCHEN

Definicja kolumny LASTMODIFIEDDT tabeli CO_DICTKITCHEN

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ExternalId tabeli CO_DICTKITCHEN

Definicja kolumny ExternalId tabeli CO_DICTKITCHEN

Name

ExternalId

Code

ExternalId

Data Type

NUMBER(10)

Mandatory

No

Comment

StockId w module Pharmacy


Lista kluczy tabeli CO_DICTKITCHEN

Name

Code

Primary

PK_CO_DICTKITCHEN

PK_CO_DICTKITCHEN

X


Klucz PK_CO_DICTKITCHEN tabeli CO_DICTKITCHEN

Definicja klucza PK_CO_DICTKITCHEN tabeli CO_DICTKITCHEN

Name

PK_CO_DICTKITCHEN

Code

PK_CO_DICTKITCHEN

Primary

Yes

Comment